import pymysql

def openConn():
    conn = pymysql.connect(
        host="47.92.33.31",
        port=3306,
        user="javateam",
        password="123456",
        db="musicdb",
        charset="utf8"
    )
    cursor = conn.cursor()
    return conn,cursor


def closeConn(conn,cursor):
    cursor.close
    conn.close()